How to: Apply a filter to records in a table.
Solution:
To apply previously existing filter, select the 'Records' menu and select 'Apply Filter/Sort'.
1)
If the Database window is not active,
activate the Database window.
2)
Open the table in the Table Datasheet view
.
3)
Select the 'Records' menu and select 'Apply Filter/Sort'. (The last filter used is applied to the open table.)